Tabela LumpSumFinPerfContractService

Definicja tabeli LumpSumFinPerfContractService

Name

LumpSumFinPerfContractService

Code

LumpSumFinPerfContractService

Comment

PL: ostateczna definicja wykonanej pozycji wraz z restrykcja oraz wyliczona data wykonania wg restrykcji


Lista kolumn tabeli LumpSumFinPerfContractService

Name

Code

ContractServicePerfID

ContractServicePerfID

Status

Status

ContractNo

ContractNo

ConContractServCode

ConContractServCode

Distinction

Distinction

ContractServCode

ContractServCode

DateRestriction

DateRestriction

FinalStopDT

FinalStopDT

UnitPrice

UnitPrice

Points

Points

NfzOrgUnitCode

NfzOrgUnitCode

NfzOrgUnitName

NfzOrgUnitName

OrgUnitCode

OrgUnitCode

OrgUnitName

OrgUnitName


Kolumna ContractServicePerfID tabeli LumpSumFinPerfContractService

Definicja kolumny ContractServicePerfID tabeli LumpSumFinPerfContractService

Name

ContractServicePerfID

Code

ContractServicePerfID

Data Type

NUMBER(10)

Mandatory

No

Comment

id wykonania PCS


Kolumna Status tabeli LumpSumFinPerfContractService

Definicja kolumny Status tabeli LumpSumFinPerfContractService

Name

Status

Code

Status

Data Type

NUMBER(10)

Mandatory

No

Comment

status pozycji rozl.


Kolumna ContractNo tabeli LumpSumFinPerfContractService

Definicja kolumny ContractNo tabeli LumpSumFinPerfContractService

Name

ContractNo

Code

ContractNo

Data Type

VARCHAR2(48)

Mandatory

Yes

Comment

numer umowy


Kolumna ConContractServCode tabeli LumpSumFinPerfContractService

Definicja kolumny ConContractServCode tabeli LumpSumFinPerfContractService

Name

ConContractServCode

Code

ConContractServCode

Data Type

VARCHAR2(32)

Mandatory

Yes

Comment

kod produktu kontr.


Kolumna Distinction tabeli LumpSumFinPerfContractService

Definicja kolumny Distinction tabeli LumpSumFinPerfContractService

Name

Distinction

Code

Distinction

Data Type

NUMBER(10)

Mandatory

No

Comment

wyroznik


Kolumna ContractServCode tabeli LumpSumFinPerfContractService

Definicja kolumny ContractServCode tabeli LumpSumFinPerfContractService

Name

ContractServCode

Code

ContractServCode

Data Type

VARCHAR2(32)

Mandatory

Yes

Comment

kod produktu jedn.


Kolumna DateRestriction tabeli LumpSumFinPerfContractService

Definicja kolumny DateRestriction tabeli LumpSumFinPerfContractService

Name

DateRestriction

Code

DateRestriction

Data Type

VARCHAR2(3)

Mandatory

Yes

Comment

restrykcja


Kolumna FinalStopDT tabeli LumpSumFinPerfContractService

Definicja kolumny FinalStopDT tabeli LumpSumFinPerfContractService

Name

FinalStopDT

Code

FinalStopDT

Data Type

DATE

Mandatory

No

Comment

wyliczona data z restrykcji


Kolumna UnitPrice tabeli LumpSumFinPerfContractService

Definicja kolumny UnitPrice tabeli LumpSumFinPerfContractService

Name

UnitPrice

Code

UnitPrice

Data Type

NUMBER(19,4)

Mandatory

No

Comment

cena za punkt


Kolumna Points tabeli LumpSumFinPerfContractService

Definicja kolumny Points tabeli LumpSumFinPerfContractService

Name

Points

Code

Points

Data Type

NUMBER(15,4)

Mandatory

No

Comment

liczba punktów


Kolumna NfzOrgUnitCode tabeli LumpSumFinPerfContractService

Definicja kolumny NfzOrgUnitCode tabeli LumpSumFinPerfContractService

Name

NfzOrgUnitCode

Code

NfzOrgUnitCode

Data Type

VARCHAR2(13)

Mandatory

No

Comment

kod NFZ komórki wyk.


Kolumna NfzOrgUnitName tabeli LumpSumFinPerfContractService

Definicja kolumny NfzOrgUnitName tabeli LumpSumFinPerfContractService

Name

NfzOrgUnitName

Code

NfzOrgUnitName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

nazwa NFZ komórki wyk.


Kolumna OrgUnitCode tabeli LumpSumFinPerfContractService

Definicja kolumny OrgUnitCode tabeli LumpSumFinPerfContractService

Name

OrgUnitCode

Code

OrgUnitCode

Data Type

VARCHAR2(13)

Mandatory

No

Comment

kod jednostki wyk.


Kolumna OrgUnitName tabeli LumpSumFinPerfContractService

Definicja kolumny OrgUnitName tabeli LumpSumFinPerfContractService

Name

OrgUnitName

Code

OrgUnitName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

data pobrania danych